{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["META","交功課","交功課 (檢討)","交易查詢"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":20,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"META","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["這個 Excel 檔案專為 JK Adv 而設。必須絕對保密，不能外洩！"]
["這檔案在 MS Excel 2016 上測試過，舊的 Excel 版本未必完全支援。"]
["如果有問題或需要支援，可以拍攝有問題的畫面 whatsapp 給我。"]
["電話是 60261213 Billy。如果更改電話也要通知我。",null,null,null,null,null,"課堂links 和 summary: ","http://classes.jkjrs.club/"]
[null,null,null,null,null,null,null,"User / password 也是 jk"]
[]
[]
["userid:","(your whatsapp)"]
["pw:","(your password)"]
[]
[]
[]
["Release Note:"]
[]
["2021-04-22","Version 1.0","JK Adv 上載交易交紀錄"]

{"sheet":"交功課","index":1,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,7,2,10]]}
[null,null,"在 B5 格仔貼上交易記錄後(第1筆資料在第6行), 選擇「這版的預設類別」和「唯一編號中間文字」後才按「產生唯一編號」, 打好原因後按「上載」"]
[null,null,"贏輸點數：",27,null,null,"平均：",{"$f":"IF(OR(D3>0,E3>0),IF(D3=E3,D2/E3,\"買賣張數不相等\"), \"\")","v":27},"這版的預設類別：","1A 有諗有做(對)",null,"唯一編號中間文字：","BS1"]
[null,null,null,1,1,null,"拎 SP/IB 交易紀錄教學","注意：唯一編號/Unique Key 不能重複，否則會上載錯誤。\n第4和第5行重覆是用來給大家對欄位次序, 欄位次序不能改。",null,null,null,"↓不填當即日","↓不填跟 J2 的選擇"]
["Unique Key","成交","名稱","買入量","沽出量","價格","時間","指示#","外部指示#","來源","狀況","即日/中線","類別","原因"]
["唯一編號","TRADES","Name","BQty","SQty","Price","Time","Order#","Ext.Order#","Source","Status","即日/中線","類別","原因"]
["20210421-BS1-0001","MHIJ1","MHI 2021-04",0,1,28641,"2021-04-21T09:25:17",305,"F0C3D2E1:B5810023","CL","Traded","即日","1A","test"]
["20210421-BS1-0002","MHIJ1","MHI 2021-04",1,0,28614,"2021-04-21T09:25:57",306,"F0C3D2E1:B5810032","CL","Traded","即日","1A","test"]

{"sheet":"交功課 (檢討)","index":2,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,7,2,10]]}
[null,null,"可以按師父的指示，由第6行開始打檢討紀錄, 選擇「這版的預設類別」和「唯一編號中間文字」後才按「產生唯一編號」, 打好原因後按「上載」"]
[null,null,"贏輸點數：",0,null,null,"平均：",{"$f":"IF(OR(D3>0,E3>0),IF(D3=E3,D2/E3,\"買賣張數不相等\"), \"\")","v":""},"這版的預設類別：","3A 事後檢討(對)",null,"唯一編號中間文字：","RE"]
[null,null,null,0,0,null,null,"注意：唯一編號/Unique Key 不能重複，否則會上載錯誤。\n第4和第5行重覆是用來給大家對欄位次序, 欄位次序不能改。",null,null,null,"↓不填當即日","↓不填跟 J2 的選擇"]
["Unique Key","成交","名稱","買入量","沽出量","價格","時間","指示#","外部指示#","來源","狀況","即日/中線","類別","原因"]
["唯一編號","TRADES","Name","BQty","SQty","Price","Time","Order#","Ext.Order#","Source","Status","即日/中線","類別","原因"]

{"sheet":"交易查詢","index":3,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"FROM",{"$f":"TODAY()","v":"2021-04-23"},null,"TO",{"$f":"TODAY()","v":"2021-04-23"}]
[null,null,"贏輸點數：",27,null,null,"平均：",{"$f":"IF(OR(D3>0,E3>0),IF(D3=E3,D2/E3,\"買賣張數不相等\"),\"\")","v":27}]
[null,null,null,1,1]
["UK","CODE","NAME","BQTY","SQTY","PRICE","DT","SP ORDER","SP EXT ORDER","SP SOURCE","SP STATUS","TRADE PERIOD","REVIEW TYPE","REASONS"]